What is IQD file?
Answer / siddu
IQD:-- Impromptu Query definition file (Report)
Using Catalog(in Impromptu Administration) create a report,
save that report in IQD format,that one you can use as a
source(Meta Data source) in Cognos PowerPlay Transformer
| Is This Answer Correct ? | 6 Yes | 0 No |
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What is a stored procedure transformation?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
How we can confirm all mappings in the repository simultaneously?
Explain the different lookup methods used in informatica?
Why we use stored procedure transformation?
What is a parameter When and where do you them when does the value will be created
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
What are the different types of repositories created using informatica?
How u use pdf file in informatica source?
What are active transformations? Name them.