In Datastage, we have row generator stage to generate dummy
row.
Is there any such transformation in Informatica.
Thanks in advance,
Kumar
checkout and checkin in informatica 8.6
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
how will you get 21 to 30 record from 50 records?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
Which is the t/r that builts only single cache memory?
What are the uses of etl tools?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
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
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000