Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
No Answer is Posted For this Question
Be the First to Post Answer
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
What is the difference between stop and abort in informatica
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Which kind of index is preferred in DWH?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Tell me about informatica architecture.
What does role playing dimension mean?
What are session parameters ? How do you set them?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?