i have source file data empno,ename,sal 100,ram,1000
200,tyu,2000 300,gh,3000 out put as e
empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
Answer Posted / ravi
logic IS GREAT.
BUT, HOW INTEGRATION SERVICE INITIALIZES V_COUNT AS '0' , SO
THAT V_COUNT+1 RETURNS '1'?
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist some properties of sessions.
Explain what are the different versions of informatica?
What is meant by LDAP users?
In informatics server which files are created during the session rums?
What is the fact table?
define galaxy repository in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is different between the data warehouse and data mart?
How to load the data from a flat file into the target where the source flat file name changes daily?
what is song in infrmatica...?
What is dimensional table? Explain the different dimensions.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is sorter transformation?