Define maping and sessions?
Answers were Sorted based on User's Feedback
Answer / swetha
Maping: It is a set of source and target definitions linked
by transformation objects that define the rules for
transformation.
Session : It is a set of instructions that describe how and
when to move data from source to targets.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / suresh
MAPPING: it is a graphical representation of data flow from
source to target which included some business
transformation logic
SESSION: It is a set of instructions that describe how and
when to move data from source to targets.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / surya
Mapping:When a Source definition transformation and Target
definition transformation are connected in a sequence
through a ETL follow of data.Such a sequence is called
Mapping.
Session:It is a task,used to migrate the data from source
to target using some instructions by informatica server is
called Session.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is workflow monitor?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In development project what is the process to follow for an etl developer from day1
how the server recognises , if the session fails after loading the 100 records in to the target
difference between source based commit? and target based commit? which is better with respect to performance?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
can we override a native sql query within informatica? How do we do it?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is an active transformation?