| Back to Questions Page |
| |
| Question |
What is the difference between a table and the materialized
view? |
Rank |
Answer Posted By |
|
Question Submitted By :: Dilip |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | 1.Refreshing of data is possible in materialised views. we
can restrict rows of data for acces from other users in
materialised views.
above mentioned two points are not possible with table.
Thanks
Deepthi  |
| Deepthi |
| |
| |
| Question |
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? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ajitforyou |
| This Interview Question Asked @ Wipro |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | not possible  |
| Arjun |
| |
| |
| Answer | It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.  |
| Aakansha [HP] |
| |
| |
|
|
| |
| Answer | Hi,
I know this is possible but not sure how.. SQ is used for
Homogenius sources. Anyone else please try to get a
positive answer on this one.  |
| Charan [HP] |
| |
| |
| Question |
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.
|
Rank |
Answer Posted By |
|
Question Submitted By :: Rakesh |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | In expression transformation create one out put port, and
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.  |
| Prabhas |
| |
| |
| Answer | In expression write following if target field is defined
with DATE datatype:
TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'))
If target field defined with character datatype then use:
TO_CHAR(SYSDATE,'DD/MM/YYYY')  |
| Aakansha |
| |
| |
| Question |
If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this? |
Rank |
Answer Posted By |
|
Question Submitted By :: Radhika |
| This Interview Question Asked @ CTS |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | you can use normalizer or expersion transformation.  |
| Saritha |
| |
| |
| Answer | We need to use sorter,Expression and aggregator transformations to do this
1.Sort by ID
2.Take 2 variable ports one for id and one for name and store the values of id and keep on comparing with current id i.e variable is having previous id.
so,if previous id=current id then (variable name)||name otherwise only name.assign the variable name to output port
3.Use aggregator and use last or max(len(name)) to get the result  |
| Rajesh.a |
| |
| |
| Answer | In source qualifier use this query
select name from table_name group by id
now apply an aggregator transformation to concate the name
according to the group id.  |
| Somnath Pain |
| |
| |
| Question |
how many repositories can v create in informatica . |
Rank |
Answer Posted By |
|
Question Submitted By :: Pentaho |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | In Informatica 8.6 and above there can be mulitilple
repositories can be created under node.
The domain can have multiple nodes  |
| Manju |
| |
| |
| Question |
how to convert the .doc docs into .txt format using
informatica |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Hi,
What is .doc source ?
can You give some Exaple for .doc source ?  |
| Vasu |
| |
| |
| Question |
Router T/R is active but some people are saying it is also
passive which is exactly right? |
Rank |
Answer Posted By |
|
Question Submitted By :: Informaticainterview |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Hi Guys,
First of all Every Active tranformation is a Passive
transformation,But every passive not Active.
In Router Transformation there is a special feature with
Default Group.Because of Default Group its Passive.
We can avoid this Default group by Some transformation
Settings,Now its Active.
any queries let me know
srinu.srinuvas@gmail.com,,,,,  |
| Srinu |
| |
| |
| Answer | Hi,
Router is Active Transformation only.Take a small example.Lets say emp table is having salaries between 1000 and 2000.and no.of records of salary 1000 is 5 and no.of records of salary 2000 is 5 and no.of records of salary 1500 is 5 .
Now in Router we will create 2 groups and and conditions are 1group-salary >=1000 and salary <=1500 --will give 10 rows
2group-salary >=1500 and salary <=2000 --will give 10 rows
so input rows are 15 and output rows are 20.So there is a change in no.of.rows between input and output.So Router is active  |
| Rajesh.a [Informatica] |
| |
| |
| Answer | AS srinu said All Active can act as passive. Active TR
means the number of rows which is the input to the
Transformation will decrease in the output from that
transformation .
For example :- i have emp table if i write a condition
where sal>2000 then the rows will decrease after this
transformation . same when i didn't apply any condition
then that acts as Passive transformation  |
| Deva [Informatica] |
| |
| |
| Answer | @Answer2: See, you mean to say input to the router is 15
and output is 20 so router tr is active. if that is the
case, we can take one row from the expression and connect
it to two transformation, so do u say expression is also
active?  |
| Manoj [Informatica] |
| |
| |
| Question |
HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard..... |
Rank |
Answer Posted By |
|
Question Submitted By :: Harish Kakarlapudi |
| This Interview Question Asked @ TCS |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Hi,
Check with Normaliser Transformation
it will help you.
Any queries !! let me know
srinu.srinuvas@gmail.com  |
| Srinu |
| |
| |
| Answer | Hi Srinivas,
It is opp. to Normalisation process, so, i think that it
cannot be done using Normaliser transformation. Can you
give me any idea , pls...  |
| Harish Kakarlapudi |
| |
| |
| Question |
I want to run a informatica worklow after complition of
oracle procedure. That procedure is not running through
informatica and can be run at any time in database.
Informatica is in windows environment. Is it possible ? If
yes please explain. |
Rank |
Answer Posted By |
|
Question Submitted By :: Sachin Shrivastava |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | This can be possible with unix . Create a shell scripts
which first has to Execute the stored procedure or Package
and we have command to check the completion or procedure
after that use Pmcmd command in the same unix to start the
workflow.  |
| Deva |
| |
| |
| Answer | Oracle proc can create a 0 byte file at the end of the proc
and infa workflow can wait for the file (indicator file) to
begin the execution.  |
| Asha |
| |
| |
|
| |
|
Back to Questions Page |