For more Informatica Interview Questions Click Here

Fact tables will created by
(DBA people or senior architects) with PK-FK relation.
Mstly  people will create  PK-FK relation in facts After 
loading the Data in Table).

Schemas : Mostly STAR Schema.

It will be useful for u ,,,,,,,,,,,

srinu.srinuvas@gmail.com

I have a idea after sql transformation go thruogh 2 Agg 
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans

I am not confident check itonce let me know,,

Thanks
Srinu

Look up Transformatoin only,
its going to maintain existing data also in cach memory

I would use following methods

1. Create a KSH to call (pmcmd startworkflow) two workflows
one after another (or two statements in ksh). And if
required, I can check successful run of previous workflow
before running another.
2. Make use of command object in second workflow. This
object will be based on ksh which can wait on file created
by successful run of first workflow
3. Make use of even wait task as file watcher and watch a
file created by first workflow. 
4. Crude way: Determine workflow execution time. Schedule
two workflows by considering execution time difference.

as per i know
create a worklet and save the workflow in worklet and run 



please let me know is this ans is correct

please call me if this is not an correct 9912063678

The best way is obviously to run WF1 and then call WF2 
using PMCMD command in the last session of WF1(as a post 
session task).If you absolutely want to ensure that the 
second wf starts only after graceful completion of wf1 then 
simply add a command task for the pmcmd and use the piple 
to validate that the previous task is completed properly.

Please let me know if you are not clear or need more info.
Cheers!

We can do using Event Raise & Event Wait tasks in workflows

we have to create worklet . a worklet  can be used to run
multiple workflows.  a worklet is created with worklet
desinger tool.

Monster dimensions require special handling and advanced 
planning, especially when you’re dealing with rapidly 
changing monster dimensions. Rapidly changing dimensions 
(i.e., dimensions whose content changes as a result of 
input errors or changes over time that you’re recording in 
place) aren’t too much of a challenge when the dimensions 
are small. However, monster dimensions consume large 
amounts of maintenance time and CPU cycles because of their 
size, so you need to plan carefully when you’re dealing 
with them. Let’s explore two different methods for managing 
rapidly changing monster dimensions: first, splitting the 
dimension, and second, creating a set of non-overlapping 
value ranges for each rapidly changing attribute and then 
creating rows that include all possible range combinations.

HERE YOU MENTIONED ONLY 3 TRANSFORMATION, SO OUT THESE 3 
aGGREGATOR IS COSTLIEST TRANS

hi guys,
 some one  selected that Above ans is worng.. can any one 
tell correct answer.for the above Question

hey raj, pooja and savita the costliest transformatin till 
Infa7.1.4 is lookup but after Infa 8.1 it guess it sj=hould 
be JAVA.

fixed width,because there are no delimiters to check so the 
preformance will increase

Doveloping Programing tools also

source qualifier transformation represent the records that 
the informatica server reads when it runs a session.

Source qualifier is the first transformation which reads 
data from relation of FF source.
With SQ we can limit the source data or sort or aggregate 
or remove the dupliate data via SQL Query.

hi,
we use SQ trans as 1st trans due to its properties. in SQ 
trans i means at the begin of extracting of data its self 
we can remove duplicate ,we can filter,join,override the 
query,pre and post sql querey.... in orther words we use it 
to impore the performance.

Source Qualifier Transformation basically converts 
different data types to Informatica Compatible Data types. 

The additional Feature of it to allow the developer to 
override the SQL (Only while reading database sources) adds 
better design in the map. [instead of having additional 
Filters and Sorters].