how to design mapping half of source table records into one
target and remaining half into another target
Answer Posted / raj
Hi SBVP , thanks for your answer.... if i dont know the
number of records coming from my source flat file what can i
do? please tell me
thank you
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the surrogate key?
Explain the aggregator transformation?
What are the modules in Power Center
What are the informatica performance improvement tips
How do you take back up of repository?
draw informatica architecture 8.6 ?
What is meant by pre and post session shell command?
What is target load order?
Explain pmcmd command usage in informatica
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 is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
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)
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the new features of Power Center 5.0?