explain any diffcult scenario that u have faced in your
experience... or explain any complex maping u have
developed?
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?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
why we use stored procedure transformation?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
how to sort date field in infomatica?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
How can we use batches?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?