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 18908i 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 8260how 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 6259when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
1 5230when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
1 3866In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
6 7587my 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 7534my 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 7151Post New Informatica Questions
Under what condition selecting sorted input in aggregator may fail the session?
Why update strategy and union transformations are active?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to differentiate between the active and passive transformations?
What is joiner transformation in informatica?
Enlist the various types of transformations.
What is the advantage of informatica?
How can we handle two sessions in informatica?
how many types of dimensions are available in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Is there any target staging area in informatica not staging area
In which transformation you cannot drag ports into it?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
wf dont have integration severances how you can run?
have u done any performance tuning? how u ll do?