-
Changing the rows from source to target
hi, hi can anybody answer my query... that is i had a source table containing for eg;D1,D2,D3,D4,D5 one by one that means in a each column contains single source i.e., D1 in 1st col,D2 in 2nd col so on now i want in my target like D1-D2 in one col, D1-D2_D3 in other col,D2_D3-D4 in other col and D3-D4-D5 in other col plz send as soon as possible.......... thanx in advance
Ashish
- Jul 23rd, 2011
Use expression transformation to get the desired output
sppavankumar
- Jul 18th, 2011
One can pass the input through the expression, where the variable/output ports can be configured to pass the combined value by using the CONCATENATION function of informatica.
-
Explaining Informatica projects
Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.
what is data warehouse methodology ,types of dw methodology, most using dw methodology... -
What is the main difference between mapping and mapplet designer ?
What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?
-
Can we modify the data in flat file?
sppk
- Jul 18th, 2011
The update transformation/strategy uses the concept of keys, in order to update the target table. As flat file do not have any Keys defined on it, it is not possible to update the target,. which is a flat file.
Noel Lastra
- Apr 9th, 2008
You can modify the flat file using shell scripting in unix ( awk, grep, sed ).Hope this helps.
-
How would you do mapping with flat file and Oracle as source ?
One source is flat file and other source is oracle, then how do you do the mapping?
sppavankumar
- Jul 18th, 2011
There are two possible ways of doing it: 1) Both used in a single mapping with single pipeline(Joiner can be used, in order to join both the source in the mapping) 2) Use two different pipelines in a ...
-
How do you change the transformation?
On one day there are 10 cities and the other day 5 more cities gets added? then how do you change the transformation? What do you do?
sppavankumar
- Jul 18th, 2011
If there is change in the data, there is no need to go for changing of the transformation. Instead you can insert/update the incremental data.
Please elaborate the question if not answered. -
-
How would you explain about Informatica Project ?
Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.what is data warehouse methodology ,types of dw methodology, most using dw methodology in companies...
-
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.
-
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...
-
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.
-
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
-
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 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"
-
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...
-
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)
-
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...
-
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
-
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 ...
-
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.
Informatica Interview Questions
Read Best Answer
Ans