top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the limitations for bulk loading in informatica for all kind of databases and transformations?

+2 votes
719 views
What are the limitations for bulk loading in informatica for all kind of databases and transformations?
posted May 7, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Bulk load is used for external loaders and in bulk load we will not write information to datalog file so if any
recovery is needed it is not possible.

answer May 8, 2015 by Manikandan J
Similar Questions
+2 votes
Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+2 votes
Incremental loading for fact table in informatica

I am performing SCD type 1 mapping. I have these source tables.

1.CUSTOMERS, (Source customer File)
2.PRODUCTS (Source Product File)
3.SALES   (source Sales file)

Also, these are dimensions and fact tables.

1.D_CUSTOMERS (SCD 1),
2.D_PRODUCTS (SCD 1) and
3.F_SALES_DLY (Fact)

Sales contains daily level data. Fact table will have sales & quantity data aggregated for product & for a month.(Fact table should be incremental for 24 months.(It should always contain 24 months of data)

I am bit confused, How to make fact table incremental? If i try to use any transformation(filter) to get last 24 months records, is it feasible solution?

Please suggest me something..

Thanks...

0 votes
while loading data from Teradata to Oracle using informatica powercenter, we are facing special character issue

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

...