Name at least 5 different types of transformations used in mapping design and state the use of each.?
- 0 Answers
- 674 Views
- Informatica, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the new features of the server manager in the informatica 5.0?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
When the informatica server marks that a batch is failed?
Explain what is informatica metadata and where is it stored?
How to convert flat file into xml file? How to tune joiner?
draw informatica architecture 8.6 ?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
How to add source flat file header into target file?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
Teradata 
