you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1
How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
1.How will u link a list to crosstab.?i.e link a pramater
in list so that it shows further information in cross tab.?
2.I have different regions,I want region specific logo to
be displayed when I run the report.How it is done ?
3.Among Drill through and Master detail relationship which
is more effective?
4.How do u hide a column in list report?
Ans: In properties,Burn list option-check whichever column
u wanna hide.
5.What is Roll play dimension?
6.What is Data Item Value n Parameter value?,What exactly
it ll take when select either of them?
7.How many types of filters are there?
8.What will happen if u use detailed filter ?,n what is da
result when used on summary filter?
i have a source which relational.I am trying to populate to
target flat file with one column for daily date which is
sysdate.
I want to populate the sysdate coulmn with DD/MM/YYYY
format.
kindly provide a solution for this..my clear that my target
is flat file.
how do u estimate the depth of the session scheduling queue?
Where do u set the number of maximum concurrent sessions
that Informatica can run at a given time?
70
What are the join problems comes appart from loop,chasm &
fan Traps
I have 7500 rows. I need all rows in single reports. Which
type of prompt we have used retrieving all rows and show in
a report?
We have dynamical queries q1, q2, q3, q4, q5. If customer
selects the particular, query that only show in execution
report. In case it may more then one, how do you execute the
particular query item in report page?
What are the difference bt OLDP and OLAP?
hi all of u, i want to learn the course in SAP(BI).because
of there is no calls for BO. And the another region is it
will be converted into SAP module. is it OK for me? is there
any feauture in coming days? could any one plz send me the
message
Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
60
What is DTM session?
211
Then how to select the source by using webi or deski reports
into crystal reports? i think main source is Businessview.
where u import the datasource ?