Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task

Question Posted / kumar

Answer Posted / kumar

Hi Gurus,

can anyone please explain performance tuning above logic. If multiple sources are coming from multiple databases.
Not simple use Unioni/ Joinder T/R.

Please be patience.. your explanation is very helpful to us.

thanks in advance

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to extract the informatica rejected data?

968

How to call shell scripts from informatica?

751

What are the new features of informatica 9.x at the developer level?

806

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5988

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.

1456

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1275

Under which circumstances, informatica server creates reject files?

824

Explain sql transformation in script mode examples in informatica

796

Explain the features of connected and unconnected lookup.

731

What are the main features of Oracle 8i with context to datawarehouse?

1863

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

1630

What are some examples of informatica etl programs?

728

Could you explain what is enterprise data warehouse?

747

What do you mean by blocking transformation?

774

What is the difference between a connected look up and unconnected lookup?

758