No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by filter transformation?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
Can we insert ,update ,delete in target tables with one update strategy tran.?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
What is joiner transformation in informatica?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.