Answer Posted / 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 |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is data transformation manager process?
How to join three sources using joiner?
What is union transformation in informatica?
Whats there in global repository
How to load the data from people soft hrm to people soft erm using informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How do you load only null records into target? Explain through mapping flow.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Write the different tools in the workflow manager?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Design a mapping to load a target table with the following values from the above source?
Explain load alternative records / rows into multiple targets - informatica