what is diff b/t sorter t/r and agg have the option sorter
property...
No Answer is Posted For this Question
Be the First to Post Answer
Can we use parameters of parameter file in presession command
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
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?
How do you change a non-reusable transformation to reusable transformation?
What is meant by target load plan?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
how can u avoid duplicate rows in flat file?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,