ranjan kumar mahapatra


{ City } bangalore
< Country > india
* Profession * etl developer
User No # 4902
Total Questions Posted # 7
Total Answers Posted # 10

Total Answers Posted for My Questions # 33
Total Views for My Questions # 100579

Users Marked my Answers as Correct # 87
Users Marked my Answers as Wrong # 16
Questions / { ranjan kumar mahapatra }
Questions Answers Category Views Company eMail

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

HP,

4 Informatica 19111

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

HP, TCS,

6 Informatica 17486

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

HP, Patni,

10 Informatica 21881

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

HP,

3 Informatica 10721

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

HP,

5 Informatica 14853

Three date formats are there . How to change these three into One format without using expression transformation ?

HP,

3 Informatica 10429

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

IBM,

2 Informatica 6098




Answers / { ranjan kumar mahapatra }

Question { 8986 }

What is the use of incremental aggregation?


Answer

in incremental aggregation only the captured changes will be
considered for aggregate calculation i.e. when new data will
be inserted for calcutation , informatica power center
server will not start the processing from the begining .

Is This Answer Correct ?    5 Yes 0 No

Question { 11702 }

Explain in simple terms, the concept of Data Mining.


Answer

Generally, data mining (sometimes called data or knowledge
discovery) is the process of analyzing data from different
perspectives and summarizing it into useful information -
information that can be used to increase revenue, cuts
costs, or both. Data mining software is one of a number of
analytical tools for analyzing data. It allows users to
analyze data from many different dimensions or angles,
categorize it, and summarize the relationships identified.
Technically, data mining is the process of finding
correlations or patterns among dozens of fields in large
relational databases.

Is This Answer Correct ?    25 Yes 2 No


Question { ITC Infotech, 13724 }

surrogate keys usage in Oracle and Informatica?


Answer

surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)

Is This Answer Correct ?    6 Yes 0 No

Question { TCS, 23477 }

Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse


Answer

it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .

Is This Answer Correct ?    17 Yes 2 No

Question { 21828 }

what is difference between

Independent Data Mart Dependent Data Mart
1- 1-
2- 2-
3- 3-
4- 4-


Answer

Independent datamart:it does not get data from datawrehouse
Dependent data mart: It gets data from datawarehouse.

Is This Answer Correct ?    25 Yes 6 No

Question { Wipro, 4900 }

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK
AND DATE VALIDITAION LOAD TO TARGET TABLE


Answer

code should be like this:
Check whether the pk is present, if present, its a duplicate record.
then check for the null values
then check for invalid date columns

iif(not isnull(pk),error_code_dup_rec,
iif(isnull(col1)
or (is null(col2),null_value_
present,
or is null(date),invalid_date,valid_record))

Is This Answer Correct ?    1 Yes 1 No

Question { Patni, 8491 }

in flatfile target how can u create header and footer plese
give me the comands how will u write in session properties


Answer

Please be specific about your requirement. what exactly you want to display in header and footer? So that one can provide you the correct solution.

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 15674 }

Why do flat file load is faster if you compare that with
table load ?
Please answer me.

Advance Thanks,
Manojkumar


Answer

One more answer is in general flat files are kept on the server where informatica is installed.Thats the reason flat file loading is faster.

Is This Answer Correct ?    2 Yes 2 No

Question { 6696 }

What are the issues that you have faced while moving your
project from the Test Environment to the Production
Environment? Please explain in depth

thanks in advance


Answer

One example can be:

1)missing link between one transformation to the next transformation.

Is This Answer Correct ?    1 Yes 1 No

Question { 9684 }

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?


Answer

You can use the minus keyword

Source table name is A
Target table name is B.

Query can be

select * from B
minus
select * from A

or else you can do a minus from A to B.

select * from A
minus
select * from B


Inthis way you can find the mismatch
(Note: This is just one way pf comparing)

Thanks,
Ranjan

Is This Answer Correct ?    5 Yes 2 No