Interested to Buy Any Domain ? << Click Here >> for more details...
i 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 Answers
- 9669 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / babu
U CAN WRITE SQL OVERRIDE( SELECT
DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC FROM DEPT)
AND U CONNECT SOURE TO TARGET ONLY 3 PORTS THOSE DATA TYPES
MUST BE MATCHED.
EMP-->SQ_EMP---->TRG
| Is This Answer Correct ? | 8 Yes | 1 No |
interviewer asked the this question.. i too felt that its not possible to load into target without helping primary key foreign key relation ship.. but i am looking forward for more answers.. plz if any body can...
| Is This Answer Correct ? | 0 Yes | 0 No |
What is deployemnt groups, Lables, query and dynamic deployment group.
Without source how to insert record to target?
select count(1) from emp? what is the o/p?
How many ways are there to create ports?
What you know about transaction control transformation?
What is a router transformation?
Limitation of REPLACESTR. Is there any character limitation to it.
What is partioning?how many types of partinings are there
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
How do you use reject loader.
What are the data movement modes in informatica?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Teradata 
