Hi All, I have oracle data source table and flat file target, now I want load data from oracle table source to flat file? How can I do? Which tranformation needs to this one? Please give solution with steps. Thanks in advance.

lakshmi

• May 27th, 2012

Source--->sqt/r--->Target
In session level(advanced file properties) u have to set some of the properties like output type,directory, filename and codepage type.

Answer Question  Select Best Answer

Hi All, My query take long time for running query/report. How to manage time for running fast report/query?

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

Query Performance: I would say you should check first SQL and run against directly to the database and note that it is taking the same time to fetching the data. 2) Try to avoid extra prompt in your r...

Krishna

• Dec 1st, 2011

Check your Sql Query for all Data providers in your report

In Groupby is there any measure you have.

If you have measure objects in groupby then it will take too much time run the report.

Answer Question  Select Best Answer

Kiran Venkata

• Oct 17th, 2011

Major difference b/w XIR2 and XI3.1 from the server part

1. we have a centralized server SIA which manages all the other servers in XI3.1.

2. In XI3.1 webi rich client has been introduced.

3. Security model is different regarding inheritance in XI3.1

etc

B.Nikhileswara Reddy

 Profile Answers by B.Nikhileswara Reddy Questions by B.Nikhileswara Reddy

• Jun 5th, 2011

XI r2----we used to do the webI reports in Infoview that is in the web. XI r3----we can do the webi in both infoview and rich clint that is we can do the reporting in online and offline modes. 1. W...

Answer Question  Select Best Answer

How to generate combine query in DeskI and WebI ?What are the steps to generate combine query in Deski and WebI? Give answer with example.

What are the types of dimensions? Can you explainthe each type in short?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

Conformed Dimension: Used across lines of businesses to gather information from across LOBs. Eg. if we want to know the deptnames where the avg salary of employees is more than the overall avg. Junk D...

Joe

• Aug 21st, 2012

1. Conformed Dimensions
2. Junk Dimensions

Answer Question  Select Best Answer

What are the types of slowly changingdimension ?Can you explain please types of slowly changingdimension in detail ?

vijaya

• Aug 29th, 2012

Slowly changing dimensions are 3 types. In scd-1 new data is inserted by deleting old one. so latest information is stored. In scd-2 we can maintain history of data for a particular item. new data is...

bhavikumehta

 Profile Answers by bhavikumehta Questions by bhavikumehta

• Jun 26th, 2012

SCD are of following types: type 1 - updates changes without preserving history type 2 - stores history data by maintaining versions of the updated data type 3 - either stores current and previous ver...

Answer Question  Select Best Answer