Can we override a native sql query within informatica?
No Answer is Posted For this Question
Be the First to Post Answer
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
how to through logic of informatica using the push down optimization into oracle.
Tell me about Propagate functions in informatica
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
What are the Advantages of de normalized data?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain in detail about scd type 1 through mapping.
what is size of u r database?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
Describe expression transformation?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.