Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)
Is This Answer Correct ? | 0 Yes | 1 No |
Define slowly changing dimensions (SCD)?
how does the server recongnise the source and target databases.Elaborate on this
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Identifying the bottlenecks in various components of Informatica and resolving them.
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Compare etl & elt?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
SCD2 will work on only dimension tables as well as fact Table?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
how do u handle performance issues in Informatica . where can u monitor the performance ?
How many steps etl contains?