i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
9 21432i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
5 9905how 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..!
TCS,
3 7620when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
1 5944when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
1 4799In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
6 9336my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
5 9123my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
TCS,
5 8685Post New Informatica Questions
What do you mean by worklet?
What all join we can perform in LOOKUP transformation?
Where are the source flat files kept before running the session?
lookup transformation with screenshots
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is Data Caches size?
What is informatica powercenter repository?
Write the program through which the records can be updated?
Why update strategy and union transformations are active?
is it possible to index the data in cache of lkp transformation ?
How to use pmcmd utility command?
How can you differentiate between powercenter and power map?
What are the new features of informatica 9.x at the developer level?
wat are deployement groups in informatica, how it will be used for developers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.