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
- 9895 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 the way to execute pl/sql script using informatica mapping?
From where we can start or use pmcmd?
what is the size of u r source(like file or table)?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is incremantal aggregation?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
What is the need for an etl tool?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
What are the popular informatica products?
What is confirmed fact in dataware housing?
Teradata 
