in staging we are merging the data and remove the
inconsistants data that type of situation what u will done
and type of functions u can use
No Answer is Posted For this Question
Be the First to Post Answer
What is hash partition?
When the informatica server marks that a batch is failed?
What is a design?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
how did u understand business requirement?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
explain about session partitions ?
how to work with mapplet designer in informatica?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is the surrogate key?