How do you convert single row from source into three rows into target?
No Answer is Posted For this Question
Be the First to Post Answer
hw cn v elimate dublicate values from lookup without overriding sql?
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
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?
Diffrence between 7.1,8.1 and 8.6
What are the types of data warehouses?
Explain the code page compatibility?
what are challenges that you faced in testing? give solution to it?
All active transformations r passive or not?
how to duplicates from expression transformation without using sorter before that
if the session fails after 100 records agian we have to starts the session or we go for recovery session
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Differentiate between sessions and batches?