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
- 10059 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 |
Explian the connected and unconnected lookup transformation
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
hw cn v elimate dublicate values from lookup without overriding sql?
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?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What is the Rank index port in Rank transformation?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Describe two levels in which update strategy transformation sets?
What are the basic needs to join two sources in a source qualifier?
Major difference between SQL override and Lookup Sql override
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Is stop and abort are same in informatica?
Teradata 
