Answer Posted / jang
Generally for Analaysis, users use reporting tools.. like
Cognos,BO.rtc.... so here they can analysis a product or
item 's across varies regions, departments, vendors.....
Drill up and Drill down is possible with the help of Dimensions.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
Explain how many types of dimensions are available in informatica?
how we can load rejected record's at run time?(not through bad files)
What is the command used to run a batch?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to load last n records of file into target table - informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How many number of sessions can one group in batches?
How do you promote a non-reusable transformation to reusable transformation?
What is workflow monitor?
What is the status code in stored procedure transformation?
What do you understand by SOA of Informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the mapping variable usage example in informatica