Interested to Buy Any Domain ? << Click Here >> for more details...
Without using any transformations how u can load the data into
target?
- 15 Answers
- 24700 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satya
Guys,
I totally agree with HJ, seriously folks dont get panic
with the interviewer, as long as ur correct and you are
confidant and if u r not quit. your job will find u
All the best
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do you load alternate records into different tables through mapping flow?
Explain what transformation and how many are there in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the main issues while working with flat files as source and as targets ?
What do you mean by enterprise data warehousing?
how many types of dimensions are available in informatica?
Explain the scenario which compels informatica server to reject files?
What do you mean by blocking transformation?
What is target designer and target load order?
What is informatica worklet?
