if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

TCS,

if i have a delimited file as source so how can we seperate this file into three diff targets?

TCS,

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

TCS,

what is unique constraint error ?

TCS,

How do we implement materialized view?when to use materialized view?

TCS,

What is the role of informatica in project ?Like i showed financial projects?

Amdocs,

Why we require dwh in particular projects?

Amdocs,

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

Amdocs,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

Amdocs,

how we can load rejected record's at run time?(not through bad files)

TCS,

what is row level and column level indicator?

TCS,

what is the method of error handling when session is running?

TCS,

can we use bulk loading when we use look in mapping

TCS,

how we can update a target table without update strategy and update override?

TCS,

what is target update override and when we use it?

TCS,