Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rambabu
$-- session parameter and session variable
exmple-$dbconnection
$$--mapping parameters and mapping variables
exmple-$$deptno, $$sal
$$$--
exmple-$$$sessstarttime
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the mapping variable usage example in informatica
What are the guidelines to be followed while using union transformation?
Explain the types of lookup transformation?
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,
What is session task and command task?
How to generate sequence numbers?
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)
How to extract the informatica rejected data?
Why do we need informatica?
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
How to update a particular record in target with out running whole workflow?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
