Explain the difference between mapping parameter and mapping variable?
No Answer is Posted For this Question
Be the First to Post Answer
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
What are the uses of a Parameter file?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
what is left outer join?
What the difference is between a database, a data warehouse and a data mart?
What are the types of metadata that stores in repository?
What is DTM process?
What are active transformations? Name them.
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
write a query for how to eliminate the duplicate rows without using distinct?
Is it possible to use a client with different version than that of its Informatica server?