Suppose on 1st Nov 2010 you had created a mapping which
includes huge aggregator calculations and it is under
process for next two days. You will notice that even on 3rd
day also its still calculating. So without changing a logic
or changing a mapping How will you troubleshot or to run
that mapping? Explain the steps
No Answer is Posted For this Question
Be the First to Post Answer
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What is predefined event?
Whats there in global repository
tell me the rules and responsblites in our project(my project is development)
what are the limitation of sorter transformation?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
in which situations do u go for scds ?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
can we load the data with out a primary key of a table? what is target plan?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
Can you generate sequence numbers without using the sequence generator transformation?