Plz can anybody send Informatica and Cognos FAQ
Plz To thid ID ppradeep_dwh@yahoo.co.in
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What is predefined event?
what type of transformation is not supported by mapplets?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
 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?
My source table having some records ,i want load 1st record and last record into one target?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
Enlist the tasks for which source qualifier transformation is 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?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5