Interested to Buy Any Domain ? << Click Here >> for more details...
My Source qualifier has empno, sal.
Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET
SAL ------------>TARGET ?
Is this mapping valid or any issues are there if we design
like this?
- 3 Answers
- 6510 Views
- Span Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek kumar
if second target is instance means name is different but
same target object than mapping is valid.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / amedela chandra sekhar
mapping is valid but we should not do like this.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is inline view?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
What are the various types of transformation?
How do you load only null records into target?
Explain sessions?
Mention a few design and development best practices for informatica?
what happens if you try to create a shortcut to a non- shared folder?
What did you do in source pre load stored procedure
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
In dimension and fact table? which one holds big data?
Teradata 
