I have flatfile it contains 'n' number of records. i need to load half of the records to on - Latest Interview Questions & Answers - Informatica Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

INFORMATICA

DETAILS

Question: I have flatfile it contains 'n' number of records.
i need to load half of the records to one target table another half to another target table.

plz any one can explain me the procedure.

Answer: No answer available currently.

Category	Informatica Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7676 users
Added on	8/5/2015
Views	69735
Rate it!

Question: I have flatfile it contains 'n' number of records.
i need to load half of the records to one target table another half to another target table.

plz any one can explain me the procedure.

Answer:
No answer available currently. Be the first one to reply to this question by submitting your answer from the form below.

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	i have source like 1;2:3.4 its flatfile. now i want in my target table as 1 2 3 4 plz can any one explain me the procedure how to get output like dat	View Answer
	If I get a flat file as source, I need to get distinct data in the target. How do I accomplish this? Please give a detailed answer of what all trasformations we have to use and how the data flow will be, and what SQL statement we have to use.	View Answer
	What is Dimension table Exactly?	View Answer
	what are load types in informatica and what is delta load	View Answer
	Where to store informatica rejected data? How to extract the informatica rejected data ?	View Answer
	How can i transform row to column?	View Answer
	What is the difference between filter and lookup transformation?	View Answer
	How a two dimension array is initialize with pointer?	View Answer
	Diff between static and dynamic cache? and please explain with one example?	View Answer
	What is pushdown optimizations in pc 8.x with example?	View Answer
	What is the difference between informatics 7x and 8x and what is latest version?	View Answer
	I have windows xp. I was told a person could find out what sites a person is looking on your computer. How do you do this. I have a person who uses my computer, and I think he is looking at sites he should not be viewing.	View Answer
	Explain about Informatica server Architecture?	View Answer
	There are 1000 source tables containing the same data with different file formats,now i want to load into a single target table ..how to achieve ?	View Answer
	Which tasks can be performed on port level(using one specific port)?	View Answer
	The designer includes a "Find" search tool as part of the standard tool bar. What can it be used to find?	View Answer
	What is meant by aggregate fact table and where is it used?	View Answer
	Is sorter an active or passive transformation?What happens if we uncheck the distinct option in sorter.Will it be under active or passive transformation?	View Answer
	This is a scenario in which the source has 2 cols 10 A 10 A 20 C 30 D 40 E 20 C And there should be 2 targets one to show the duplicate values and another target for distinct rows. T1 T2 10 A 10 A 20 C 20 C 30 D Which transformation can be used to load data into target? 40 E	View Answer
	What is the need and when do we use a dynamic lookup cache?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Informatica Interview Questions & Answers - Exam Mode / Learning Mode