What are set operators in Oracle
Answers were Sorted based on User's Feedback
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is Code Page Compatibility?
Explain sessions and how many types of sessions are there?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
How we can create indexes after completing the loan process?
Explain the difference between mapping parameter and mapping variable?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What all join we can perform in LOOKUP transformation?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
What is workflow monitor?
what is the difference between lookupoveride and joiner?