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
- 4979 Views
- Span Systems, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
mapping is valid but we should not do like this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is workflow monitor?
how to create user defined function (udf) in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the measure objects?
How to start a workflow using pmcmd command?
What is a shortcut and copy in Informatica and how two are different with each other?
What is the need of etl tools?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain the use of aggregator cache file?
What are the features of complex mapping?
Briefly describe lookup transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is expression transformation?
