list and discuss two approaches for updation of target table in Informatica and how they are different.

2118

What is data cleaning?

950

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

940

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2036

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2223

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2194

What is grain of fact?

988

Explain about etl data integration software?

897

what is session partitioning?

1886

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1791

What are the different Lookup methods used in Informatica?

925

What are materialized views & where do we use them?

1011

Explain etl mapping sheets?

1083

What is fact? What are the types of facts?

1122

Identifying the bottlenecks in various components of Informatica and resolving them.

1941