What is the difference between Active and Passive transformation?
No Answer is Posted For this Question
Be the First to Post Answer
If a table contains 100 records we have to fetch 50-100 records from source to target?how
How to load last 10 records of flat file in to the target?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What is a pre-defined event and user-defined event?
h0w many versions have been developed of onformatica so far?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
what is inline view?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Design a mapping to get year of join for each employee.
Mention few power centre client applications with their basic purpose?
How to create Target definition for flat files?