What is the difference between writing a joiner query in
ANSI style and THETA style?
No Answer is Posted For this Question
Be the First to Post Answer
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.
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
How to identify this row for insert and this row for update in dynamic lookup cache
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
Where should yoU place the flat file to import the flat file defintion to the designer?
What are the new features of Power Center 5.0?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
What is a taget load order?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
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?