Without using any transformations how u can load the data into
target?
Answer Posted / suri
it is not possible to load data form source to target with
out using transformation the reason is while loading the
data from source to targets there will be definitely
modifications in changing the data for example to calculate
the rank of the table like that.... simply the interviewer
will twist us . how we r confident in the subject .....
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
Explain the informatica workflow?
What is the benefit of partitioning a session?
define galaxy repository in informatica
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
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 is lookup transformation?
What is the difference between router and filter?
What is rank transformation in informatica
Explain the code page compatibility?
what is SDLC way of code development?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C