Interested to Buy Any Domain ? << Click Here >> for more details...
Consider two cases:
(1) Power Center Server and Client on the same machine
(2) Power Center Sever and Client on the different machines
what is the basic difference in these two setups and which is recommended?
- 2 Answers
- 4210 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satyasudhir
only one person can access server if server and client are in same machine.
Lot of persons can access the server if both are different.
I mean to say...
Just you install the server in any Linux machine and configure u r local (one or more) machine to access that server.
correct me if I am wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
That's absolutely correct. Client and Server should be in different machines because of security purpose, safety issues & obviously for more access.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why we use lookup transformations?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
what is diffrence b/w joner and union transfermation
How can you differentiate between powercenter and power map?
What is primary and backup node?
In development project what is the process to follow for an etl developer from day1
What are the designer tools for creating transformations?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
What is a predefined event?
What are the data movement modes in informatica?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
Teradata 
