can we generate reports in informatica ? How?
Answers were Sorted based on User's Feedback
Answer / j.david sukeerthi kumar
Yes we can, by using Informatica Metadata driven reporting Tool
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sub
Depends on what sort of reporting you want.As someone
already suggested you can get it using MetaData Manager but
the better way is using Data Analyzer. If you want to get
to have auto document generated then use INFA stencil.
Hope that answers your question.
Cheers!
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / mukesh
no,we cannot generate a report ,but also we generate a meta
data report because informatica is a etl tool
Is This Answer Correct ? | 1 Yes | 7 No |
What is a standalone command task?
what is the diff b/w union and joiner and lookup?
What is the difference between stop and abort in informatica
what is lookupoverriding?
What is depict expression change?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
what is the necessity to use update strategy?(except for updates)
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,