How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
No Answer is Posted For this Question
Be the First to Post Answer
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Why we select the table which has minimum number of records as Master table in joiner?
What is the fact table?
Explain the etl program with few examples.
How do you create single lookup transformation using multiple tables?
write a query to get maximum salary from the employers table without duplicates....kindly help me
HOW DO YOU PARFORM INCREMENTAL LAOD ?
what is difference between dimention table and fact table?
How to load only the first and last record of a flat file into the target?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same