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 19016i 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 8308how 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 6307when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
1 5261when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
1 3906In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
6 7656my 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 7601my 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 7221Post New Informatica Questions
Where is metadata stored?
How you know when to use a static cache and dynamic cache in lookup transformation?
How do you set a varible in incremental aggregation
How to join three sources using joiner? Explain though mapping flow.
Explain the tuning lookup transformation - informatica
Can we override a native sql query within informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the differences between oltp and olap?
Separate from an archive server and a powerhouse?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What do you mean by filter transformation?
What is data movement mode in Informatica and difference between them?
What is the status code in stored procedure transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
