-
What is the logic will you implement to load the data in to one fact from 'n' number of dimension tables.
ahammed
- Aug 2nd, 2010
First load the data into dimension table. If all the dimension data loaded is succeded then only load all dimension tables data into fact table.
-
Union Transformation
Why Union transformation is active while it returns same number of rows as in the sources?
prashant.baranwal
- Sep 18th, 2010
Union transformation is an active transformation and it does changes the number of records.Suppose source has following columns:Name, School, CollegeABC, SKM, IIT-DXYZ, DAV, IIMThere are total 10 rows...
harikr
- Dec 1st, 2009
An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.Union Transformation does UNION ALL; hence...
-
Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?
Racp238
- Apr 3rd, 2008
Why not just use an inline select statement in your sql qualifier to eliminat the overhead of a lookup transformation all together?
Vani_AT
- Apr 3rd, 2008
Connected and Unconnected lookups have their own pros and cons.Unconnected lookup is designed for a specific purpose.The task that an unconnected lookup does can be done by a connected lookup also. Th...
-
How to load time dimension?
manisha.sinha
- Dec 29th, 2006
create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...
kumar
- Sep 28th, 2006
For loading data in to other dimensions we have respective tables in the oltp systems..But for time dimension we have only one base in the OLTP database. Based on that we have to load time dimension. ...
-
What is the difference between Narmal load and Bulk load?
hanimi
- Apr 28th, 2011
Bulk load the dwh server bypass the data to the target, in that we have session performance improves.in normal load data moves the database log file.
Ray
- Mar 22nd, 2006
Also remember that not all databases support bulk loading. and bulk loading fails a session if your mapping has primary keys
-
My source is having 1000 rows. i have brought 300 records into my ODS. so next time i want to load the remaining records. so i need to load from 301 th record. when ever i start the work flow again it will load from the begining. how do we solve this problem. thanks in advance kiran
-
Compare Data Warehousing Top-Down approach with Bottom-up approach
vikota
- Apr 12th, 2011
Top-Down approach means first create the datawarehouse for entire organization then divide it into for each specific subject are called datamartsBottom-Up approach means first create the data marts then by combining all data marts create the datawarehouse
samirdesai999
- Jun 13th, 2009
Top Down-------------To build an mammoth enterprise data warehouse iteratively considering all enterprise needs and then feed individual departmental data marts.Bottom Up------------To build ...
-
-
Informatica error while creating system DSN
Hi,Can you please tell me whether Informatica 7.1.1 powercenter version can be installed on windows XP professional. Iam trying to install both client and server on the same machine.But when Iam trying to create a system DSN from Source Analyzer menu, the application gets terminated it self.Please advise me if it should work.Thanks,
mr.kishorev
- Feb 9th, 2010
Yes, you can install the power center 7.1.1 in windows XP,1. Create a new user account in Oracle. and give grant and commint previliges to that account.2. Configure informatica server by giving the de...
kolli.siva
- Dec 26th, 2006
YES, u can install INFORMATICA POWER CENTER 7.1.1 version on WINXP.It works fine.check out once by creating a new DSN.
-
What is Join index
Hi everyone ,Can u explain in detail what is a join index,with example.And what is its importance in teradata.
Read Best Answer
Editorial / Best Answer
rin23- Member Since May-2011 | May 12th, 2011
A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the way that it is used automatically by the database system to improve the performance of a query. Join indexes use the "classic" space-time trade off trading disk space for storage of the join index to get improved performance for queries. Unlike many other materialized view implementations, Teradata join indexes are updated immediately and automatically when changes are made to the base tables. There is never a concern that you might be using stale data when the system chooses to use a join index in the query plan. Also, Teradata uses its sophisticated coverage testing algorithm to minimize the cost associated with join index maintenance.?
rin23
- May 12th, 2011
A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the ...
-
How will you use sarogate key?
KevinKWada
- May 23rd, 2011
Surrogate key. A key with no business meaning.Natural key. A key that is formed of attributes that already exist in the real world. For example, U.S. citizens...
Rishikesh
- Aug 25th, 2006
HI, Surrogate key is generated using Sequence generator .it is used in slowiy changing dimension mappings rishi
-
Why session fails when running a workflow
Could anyone tell me why session fails when running a workflow? I do not see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.
rohit1505
- Mar 21st, 2011
Read the session log file, and also do check weather your target table is generated or not because if you are getting the result as 'now rows selected' then this might be one of the reason. You need to generate target table in designer itself.
anupama2000
- May 26th, 2008
Hi,Kamal1.check the preview data option in your source in mapping if the data comes to your srce then go for second stepif the data is not previewed check the source DSN2.check username of your sourc...
-
What are the difference between view and materialized view?
pkshve
- Sep 13th, 2010
View is just a SQL statement stored in Database which is executed every single time its called.Materialized view (MV) is SQL statement and its resultant data stored in database in some form ...
Shekhar Pandit
- Sep 15th, 2006
DMLs can be used against view (if they are based on 1 table with no aggr funs)
-
Parameters and variables in Informatica
What do u mean by parameters and variables in informatica and how it is used?
Neelakantan Sthanumoorthy
- Jun 9th, 2006
Parameters are constants in informatica , and they cannot be changed in a lifecycle of a mapping .Its a constant set before a mapping runs . Variables can be changed during a mapping run .When you use...
balanagdara
- May 17th, 2006
HiParameterA mapping parameter represents a constant value that you can define before running a session. A mapping parameter retains the same value throughout the entire session.VariableA mappin...
-
How to load to the target which already contains data
Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
Jaspreet_banga
- Jun 8th, 2011
First of all alter the old target table in oracle and create another new table using query as CREATE TABLE new_table AS SELECT * FROM old_table, now import this table into the ta...
padamalacharan
- Aug 25th, 2010
If the target is flatfile 'check' the option at session level:"append if exists"
-
How do you separate counts for nulls and blank value records from flat file source?
In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish
Jaspreet_banga
- Jun 8th, 2011
For This first of all replace the null values by some default values and blank values by other default values then use Count(*) operator in select clause along with IN statement EG:-SELECT COUNT(*) FROM table_name WHERE coulmn_name IN('default_1','default_2');
S.Velava
- Apr 13th, 2010
Use aggregate transformation with count to specify the null and blank.Count with the condition of not equal to null to get the count of blank values and as well to get the count of null values chk with the Null.
-
How to join the tables when there is no matching point and related keys?
What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?
Jaspreet_banga
- Jun 8th, 2011
For such type of Join we can use INNER JOIN, The best example for this is when we fetch data from a flat file source and the date for which the data has to be fetched is taken from a table known as jo...
hundwanipankaj
- Apr 5th, 2010
Dimension table types 1. Slow changing dimensions 2. Junk dimensions 3. Confirmed dimension 4. Degenrated dimension
-
Pull data from SAP Financials using Informatica
Hi, I want to know the processes for pulling the data from SAP Financials using informatica and write scripts to locate the required data.Thank you.
-
Which transformation replaces the look up transformation?
srinivas.j.abinitio
- Jul 1st, 2011
Hi ,Look up transformation does not replaces with using joiner transformation.because joiner return multiple matching values but look up can't return multiple matching values(look up policy multiple m...
xgeneration
- May 25th, 2008
as u mensioned that a joiner transformation can be used to work out the functionality that of look-up using master outer join,but what if the source is from different database & source from dff da...
-
Can u generate reports in Informatcia?
Yes. By using Metadata reporter we can generate reports in informatica.
srinivas.j.abinitio
- Jul 1st, 2011
Yes.?with using informatica Reporting too is informatica Analyzer.Thanks&Regards,Srinivas.
Informatica Interview Questions
Read Best Answer
Ans