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.
- 0 Answers
- 1781 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Does an informatica transformation support only aggregate expressions?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
how many ways can we implement SCD2?
i have 2 session s1 execute s2 load first session fail what is the reason?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Which will beter perform IIf or decode?
Did u used latest transformations of 8.6.0? for what?
why union transformation is active transformation?
What is the query to find nth highest salary? What is the use of cursors?
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?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Teradata 
