-
-
-
Filter, Sorter, Joiner Transformations and Source Qualifier
Why do we need transformations like filter, sorter, Joiner etc when we can do all those tasks with Source Qualifier itself using queries?
-
-
Pivoting of the records
source: target:
col1 col2 col1 col2
a 1 1 a,b,c,d
b 1 2 p,q,r
c 1 3 x
d 1
p 2
q 2
r 2
x 3
how to do this...
Thanks,
krishna. -
Scenario based
If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...
-
-
Create Session log as a Parameter in Informatica Cloud
How to create a session log as a parameter in informatica cloud?
-
PreSql in Source Qualifier and PreSQL in Target in Informatica
I am not able to understand the different between PreSql in Source Qualifier and PreSQL in Target in Informatica. I read many other posts they told
pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".
So if all PRESQL run at same point... -
Transformation to Load 5 Flat files
What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?
-
-
-
-
What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.
-
Dynamic target creation using source data
Suppose in Informatica a source file has 1 column(CITY) and datas are Pune, Kol, Pune. Want to load CITY data to dynamically generated target file(means it will create 2 targets, named Pune and Kol and in Pune target, value will be Pune and in Kol target, value will be Kol) ?
-
-
How do I pass a argument retrieved from a mapping to a command task?
In a unix environment I have an application that takes several arguments. One of these I get from a session mapping. How do I pass this argument into my application?
-
Index and Data Cache Files
Assuming that the master pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation.then How many fields are in the index and data cache files?
options:
a. 5 fields are in index and 3 in data cache
b. 3 fields are in index and 2 in data cache
c. 2 fields are in index and 3 in data cache
d.... -
What r the options in the target session of update strategy transsformatioin?
Insert Delete Update Update as update Update as insert Update esle insert Truncate table
-
Informatica Interview Questions
Ans