What are the associated ports in look up T/R.
Answer Posted / sivak
by using associated port we can generate sequence numbers
with out using sequence generator t/r.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
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
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How you can differentiate between connected lookup and unconnected lookup?
What is dimensional table?
How do you convert single row from source into three rows into target?
What is a connected transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
differences between service based and product based?
What do you mean by worklet?
What is the way to execute pl/sql script using informatica mapping?
What are the different clients of powercenter?
What is the status code in stored procedure transformation?