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
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between a shortcut of an object and copy of an object? Compare them.
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Explain about Informatica server process that how it works relates to mapping variables?
Why should we use star schema in datawarehouse design?
Enlist the differences between database and data warehouse.
What is source qualifier?
I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?
Can anyone tell me the new features in Informatica 9 Version?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
How can you complete unrcoverable sessions?