What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
No Answer is Posted For this Question
Be the First to Post Answer
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
Where is the cache stored in informatica?
How we can confirm all mappings in the repository simultaneously?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
What are the advantages of informatica?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
How we can use union transformation?
Differentiate between reusable transformation and mapplet.
Write the different tools in the workflow manager?
permutations of mapplet
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?