Diff B/W
MAP Parameter,
SESSION Paramater,
DataBase connection session parameters.?
Its possible to Create 3parameters at a time?
If Possible which one will fire FIRST?
Answer Posted / sasmita panda
If we need to change certain attributes of a mapping after
every time the session is run, it will be very difficult to
edit the mapping and then change the attribute. So we use
mapping parameters and variables and define the values in a
parameter file. Then we could edit the parameter file to
change the attribute values. This makes the process simple.
In a mapping parameter we need to manually edit the
attribute value in the parameter file after every session
run
Session parameters are like mapping parameters, that
represent values you might want to change between sessions
such as database connections or source.
Yes it is possible to create 3 parameters at a time.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
what is the difference between informatica6.1 and infomatica7.1
Briefly define a session task?
what is size of u r database?
What are the tasks that source qualifier perform?
What are the main features of Oracle 8i with context to datawarehouse?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Make a note of the quantity vaults made in informatica?
How do you handle two sessions in Informatica
Define sessions in informatica etl?
How can we improve session performance in aggregator transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps