Interested to Buy Any Domain ? << Click Here >> for more details...
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 21411i 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 9885how 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 7601when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
1 5920when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
1 4789In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
6 9326my 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 9104my 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 8679Post New Informatica Questions
How would you copy the content of one repository to another repository?
What are the settings that you use to configure the joiner transformation?
Enlist the differences between database and data warehouse.
What is substr in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are active and passive transformations?
Explain pmcmd command usage in informatica
Enlist few areas or real-time situations where informatica is required.
Explain the difference between mapping parameter and mapping variable?
What is union transformation?
What is the use of an aggregator cache file?
How to create or import flat file definition in to the warehouse designer?
What are the data movement modes in informatica?
What is informatica etl tool?
