One of the optimizing technique to improve the session
performance is push down optimization,by using push down
optimization we push as much as transformation logic to
source/target database,but this degrades the d/b
performance,how to overcome this?
No Answer is Posted For this Question
Be the First to Post Answer
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
Useful UNIX commands regular/frequently used
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
what is the diff b/w union and joiner and lookup?
how can we calculate fact table size?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
How to extract sap data using informatica? What is abap? What are idocs?
update strategy transformation in informatica
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What are the types of schemas we have in data warehouse.
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?