Interested to Buy Any Domain ? << Click Here >> for more details...
how we load the data from source to staging area
- 4 Answers
- 8809 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manik
By using one to one mapping we can load data into staging area like how we will load Flat file data into staging relational table.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the query to find nth highest salary? What is the use of cursors?
How do we call shell scripts from informatica?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
What is galaxy shema
What is the difference between stop and abort in informatica
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
What is aggregate cache in aggregator transforamtion?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain what transformation and how many are there in informatica?
Teradata 
